<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>

<body>
<?php  include 'action/session_check.php'; //登录判断  ?>  
<form action="" method="post">
<table>
<tr>
<td colspan="11"><h2>投递信息处理</h2></td></tr>
<tr>
    <td>序号</td><td>性别</td><td>姓名</td><td>学历</td>
    <td>投递职位</td><td>职位所属类别</td><td>投递时间</td><td>状态</td><td colspan="4">操作</td>
   </tr>
 <?php
  include("../conn/conn_db.php");    //包含数据库连接文件 
  $sql = "select * from  file_info order by f_id asc"; //查询语句
  $result = $conn->query($sql);                //执行SQL语句
  while($row = $result->fetch_array())   //遍历查询结果的每一行
  {
?>
  <tr>
    <td> <?php echo $row["f_id"];?>   </td>
    <td> <?php echo $row["u_sex"];?></td>   
    <td> <?php echo $row["u_name"];?></td>
    <td> <?php echo $row["u_education"];?>  </td>
    <td> <?php echo $row["r_name"]; ?></td>
    <td> <?php echo $row["rt_name"];?> </td>
    <td> <?php echo $row["f_time"];?> </td>
	<td>
    <?php switch ($row["status"])
       {
     	case '1':
     		echo '<font color=red>未查看</font>';
     		break;
     	case '2':
     		echo '<font color=blue>邀请面试</font>';
     		break;
     	case '3':
     		echo '不符合职位要求';
     		break;
       }
     ?> 
    <td><a href="../../<?php echo $row['u_file']; ?>" target="_blank">查看资料</a></td>
	<td><a href="action/file_action_do.php?Type=1&f_id=<?php echo $row["f_id"];?>">审核通过</a></td>
	<td><a href="action/file_action_do.php?Type=2&f_id=<?php echo $row["f_id"];?>">不符合</a></td> 
	  
  </tr>
<?php }  ?>
 </table>
 </form>
<br><br>

<form action="action/file_upload_do.php" method="post">
<table>
<tr>
<td><h2>上传文件</h2>

    <h5>!注意上传文件要压缩!</h5>
</td>
</tr>

 <?php
  include("../conn/conn_db.php");    //包含数据库连接文件 
  $sql = "select * from recruit_info where rt_id = 8 order by r_createtime desc"; //查询语句
  $result = $conn->query($sql);                //执行SQL语句
  while($row = $result->fetch_array())   //遍历查询结果的每一行
  {
?>
  <tr>
	
    <td>
		|--<?php echo $row["r_name"];?>所需填写文件
	</td>
	<td><a href="file_upload.php?r_id=<?php echo $row['r_id'];?>">点击上传</a></td>
</tr>
<?php }  ?>
 </table>

 </table>
 </form>
</body>
</html>